Spreadsheet Homework 2

Create a spreadsheet that calculates simple and compound interest
at 6% on a deposit of $1000, for 20 years.

Your spreadsheet should look something like this.  

Firstname Lastname (MUST BE TYPED!)
Spreadsheet Homework #2: Simple and Compound Interest

	Interest Rate:
	6%

	Simple:								|Compound:
Years 	Rate		Main	Int.	Interest	Combined	|Compound	Interest
since	This		Balance Earned	Balance		Simple		|Balance	Earned
start  	Year			ThisYr	at start	Balance		|		This Year
					of year				|
0	6%		$1000	$60	 $0		$1000		|$1000.00	$60.00
1	6%		$1000	$60	 $60		$1060		|$1060.00	$63.60
2	6%		$1000	$60	 $120		$1120		|$1123.60	$??.??
etc
20	6%		$1000	$60	 $???		$????		|$????.??	$???.??

The question marks are numbers that you will have to determine.
You should not do the calculations by hand or copy from anywhere--
instead, type formulas in to the spreadsheet.  No numbers (like 0 or 60 or 120) should
appear in your formulas on or below year #1.